package cn.edu.stu.mapper;

import cn.edu.stu.bean.MicSong;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface MicSongMapper {
    int deleteByPrimaryKey(Integer songId);

    int insert(MicSong record);

    MicSong selectByPrimaryKey(Integer songId);

    List<MicSong> selectAll();

    int updateByPrimaryKey(MicSong record);

    @Select("select song_id from mic_song where song_md5 = #{md5}")
    Integer checkIdByMD5(String md5);

    @Select("select * from mic_song where song_md5 = #{md5}")
    List<MicSong> selectByMD5(String md5);
}